SAGEMAS90CONSULT
Technical User
MAS 200 V.4.2.0.15
Occasionally a customer invoice created in Sales Order Invoice Data Entry will post in duplicate or triplicate to both A/R and G/L. If it has posted in duplicate, when you look up the invoice on the Customer Maintenance Invoices tab, the same invoice number is listed twice. In the “Trans Type” column, the first invoice is listed as “Invoice” but the duplicate is listed as “Adjustment,” and the “Trans Amount” is the same for both invoices. By standard procedure, if a SO Invoice needs to be adjusted, it is done by entering a Credit Memo or Debit Memo in SO Invoice Data Entry. So there is never any “Adjustment” done to the invoices, so the system is assigning this “Adjustment” title to the duplicate invoice.
The invoices post to G/L in double or triple the amount of the invoice posted. An A/R Invoice History Report shows the invoice listed twice or three times and the line items are listed two or three times, as well as the increased posting to Inventory, Accts Rec, Sales, COGS, etc. - all doubled or tripled. At least the postings are consistent in GL and other modules/accounts.
I searched the Sage KB and found nothing there. The Sales Orders and following Sale Order Invoices have been entered manually and not from a VI import or other Auto generation task such as SO from PO, nor is there an extended solution used.
A review of the DSOSJ when the SO Invoices are posted does not show anything unusual. Sometimes the duplicate invoices are not discovered until the customer’s payment is applied in Cash Receipts, and the AR Clerk finds the duplicate invoices and the Customer Balance is incorrect.
A shout out to anyone who may know what may be the suspect. Thanks in advance.
Occasionally a customer invoice created in Sales Order Invoice Data Entry will post in duplicate or triplicate to both A/R and G/L. If it has posted in duplicate, when you look up the invoice on the Customer Maintenance Invoices tab, the same invoice number is listed twice. In the “Trans Type” column, the first invoice is listed as “Invoice” but the duplicate is listed as “Adjustment,” and the “Trans Amount” is the same for both invoices. By standard procedure, if a SO Invoice needs to be adjusted, it is done by entering a Credit Memo or Debit Memo in SO Invoice Data Entry. So there is never any “Adjustment” done to the invoices, so the system is assigning this “Adjustment” title to the duplicate invoice.
The invoices post to G/L in double or triple the amount of the invoice posted. An A/R Invoice History Report shows the invoice listed twice or three times and the line items are listed two or three times, as well as the increased posting to Inventory, Accts Rec, Sales, COGS, etc. - all doubled or tripled. At least the postings are consistent in GL and other modules/accounts.
I searched the Sage KB and found nothing there. The Sales Orders and following Sale Order Invoices have been entered manually and not from a VI import or other Auto generation task such as SO from PO, nor is there an extended solution used.
A review of the DSOSJ when the SO Invoices are posted does not show anything unusual. Sometimes the duplicate invoices are not discovered until the customer’s payment is applied in Cash Receipts, and the AR Clerk finds the duplicate invoices and the Customer Balance is incorrect.
A shout out to anyone who may know what may be the suspect. Thanks in advance.