×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

S/O Invoice posts in duplicate or triplicate to A/R and G/L

S/O Invoice posts in duplicate or triplicate to A/R and G/L

S/O Invoice posts in duplicate or triplicate to A/R and G/L

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close