#12 rdb DAL for invoices

[Vincent (Bryan) Coen]

CRITICAL ERROR:

The following programs found in the common folder have bugs :
invoiceMT.scb
autogenMT.scb

Where * = sl and pl

Issue is that for write and rewrite operations they do not have code or the correct code to handle the RG1 (linvoice lines) tables for sales and purchase and this includes the autogen (recurring invoices).

Operation will result in invalid key or key not found or invalid field acting as the key - The exact message may differ.

Cause is that there is no code to set up the second key needed for the RG1 records.

This only applies when using the MySQL or mariadb data bases and does NOT effect operations when using the standard Cobol data files.

A fix is being worked on.

[Vincent (Bryan) Coen]

Fix completed for :
slinvoiceMT.scb
plinvoiceMT.scb
plautogenMT.scb
slautogenMT.scb

These all need to be tested so status will be set to pending - best to test against the approriate LD programs after creating testing sales invoice and autogen invoice and checking results including the log files.

So every one can now help test against latest night build as of tonight.

[Vincent (Bryan) Coen]

Found an issue with invoice amend when creating test invoice records. - see next bug report.
This causes problems when trying to test for this fix on *invoiceMT .
Bit of a chicken and egg issue :)

[Vincent (Bryan) Coen]

I am leaving this as pending for system and white box testing to be completed along with all the other tasks I am trying to do such as manual writing and updates, system updates etc.

I am always looking for experienced people to help on these tasks. - gentle hint :)