Friday, June 5, 2009

Invoicing with Edisoft Merchant Express

While Edisoft does a fantastic job integrating with Mas500, AccPac, Great Plains, and Mas90/200, I've worked with companies that are not integrated.
For many retailers, orders received are single store-defined-quantity orders--that is they have one Purchase Order number and each item line has several sublines with their stores(Mark For). Often these store numbers are already set up in Merchant's customer location setup with the macthing ship point(retailer Distribution Center)--for example store 0888 is matched to DC 0737, so we might have one order, 250 ultimate stores(Mark For) divided into 2 DC shipments.
Some retailers require we return via EDI one consolidated invoice per PO, others require one per ship point(4 DC's, 4 consolidated invoices). Most however, require one invoice returned per store(markfor).

With non-integrated accounting companies, we put the SDQ orders into our ERP systems as a single order as the store information not needed for accounting purposes. When we invoice in the ERP, we assign a 6 digit number.
Then to EDI the order, if they want one per store, we go into System Control numbers and select the starting invoice number. We put in first 6 digits from our ERP invoice, then put 0001.
Now back to Sales Orders and find the order in question. Tap the invoice button and do the drop down "one per PK" and choose how you would like to date---either date of invoice or ship date(which if ASN'd, should be ship date from your ASN). Select the Auto Invoice and suddenly all the stores will be invoiced(with 200 stores, xxxxxx0001-xxxxxx0200).
Wait, two more steps---
1. Go into Reports and select invoice summary---choose the invoice range, and wait for report to pop up on screen--go to last page and verify that your sum of the range matches the amount in your ERP. Take necessary steps to correct if it does not.
2. Go into the invoice screen for that customer and select all the invoices and if already mapped, just hit "create 810", and within seconds you have created the invoices for all those orders.

Your AR team now has a range for that PO and makes it easier for them to match up when the retailer's check is received.



No comments:

Post a Comment