{"id":1574,"date":"2017-09-12T06:46:38","date_gmt":"2017-09-12T06:46:38","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagemas\/?p=1574"},"modified":"2025-06-05T11:16:15","modified_gmt":"2025-06-05T11:16:15","slug":"credit-and-rebill-functionality-on-posted-invoice-in-sage-500","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagemas\/2017\/09\/12\/credit-and-rebill-functionality-on-posted-invoice-in-sage-500\/","title":{"rendered":"Credit and Rebill functionality on Posted invoice in Sage 500"},"content":{"rendered":"

Unfortunately, many times during the month, no. of Sales orders are getting shipped and sometimes the invoice containing the wrong pricing in Sage 500.<\/p>\n

In that circumstances, User needs a utility where they can enter the sales order that was billed incorrectly so that sales order will be retrieved and the user can enter the new pricing.\u00a0 Upon accepting\/saving the changes a new invoice will be generated and issued to the customer.<\/p>\n

New Stuff<\/strong><\/em>:\u00a0Migrate Item UOM from Sage 50 US to Sage 100<\/a><\/p>\n

In regards to issuing the invoice,\u00a0we are assuming that the invoice will reside in AR until a new batch is created and the invoice is posted to Accounts Receivable.<\/p>\n

Please note the following scenario as an example for the process and the posting to the general ledger<\/p>\n

Example<\/strong>.\u00a0 Oliver enters sales order number 4954 for items: Cables for $72.95.\u00a0After the order is shipped and posted the invoice no. 0000001132, the customer calls Oliver and tells him they were supposed to get a 20% discount on the frame. Oliver thinks about how we can\u00a0rebuild\u00a0the old invoice to new invoice with 20% discount.<\/p>\n

To handle this situation, Greytrix has developed a Credit and Re-bill functionality on the AR invoice screen through which Sage 500 users will be able to generate the Credit memo on the old invoice and will re-bill the new invoice with new changes.<\/p>\n

Here\u2019s the below screenshot of the same.<\/p>\n

\"Enter<\/a><\/p>\n

Posted Invoice lookup<\/strong>: \u00a0There will be a button that allows the user to select a prior invoice that was issued.\u00a0\u00a0Once User selected the Posted invoice number then a CREDIT MEMO will be issued for the old invoice and the new invoice will be ISSUED.\u00a0 The CREDIT MEMO and the newly issued INVOICE will contain a prefix in the invoices number REB= and then the number of the invoice. A screen similar to above will pop up and the user can make changes to the payment terms or the unit price.<\/p>\n

Sage 500 user will then select the utility Greytrix has written and entered the Posted invoice no 0000001132.<\/p>\n

Once user selected the posted invoice no. 000001132 the Credit and rebill functionality will generate the Credit memo for old invoice and the new invoice will be issued.<\/p>\n

A user will be able to enter the correct pricing in the detail line.\u00a0 This invoice will then be sitting in pending status until another user in accounting selects the invoices for posting at the end of the day.<\/p>\n

For general ledger posting purposes, the following will occur by using Credit and rebill functionality.<\/p>\n

1.\u00a0Credit Memo on the Old Invoice.<\/p>\n