We utilize the O/E program and transfer the information upon invoicing to A/R and then interface this information with J/C. When we transfer the information to A/R, we enter the job number into the template prior to posting. When we import the information to J/C, the billings come in as other bililngs, not invoices. The code they come in is an 8, and I want them to be a 1. Is there a way to have code 1 be default?

Hi Jim,

When an invoice in sent from OrderEntry to A/R, the distribution on the invoice is to a clearing account (as defined in OE). The scenario you are running into is that when associating a Job number on the invoice, there is an Invoice distribution detail that is specific to the Job (and uses the Billings G/L account as specified in the A/R and J/C company profiles). Only the amount that is on this job-specific distribution goes to the J/C billing as a 'type 1' bill. All other distributions go to the 'type 8' other charges details, as you have found.

Currently, there is no direct integration between OrderEntry and JobCost, which is why you are having to do the procedure you are, adding the job number to each invoice in AR before posting.

What you will need to do is move the amount in the distribution on the AR invoice created by OE, to the new JobCost-specific distribution, in order to have the JC billings rather than 'other charges'.

However, the GL accounting is also affected quite substantially. Posting AR invoices Debits the AR control account and Credits the distribution account. If you simply move the amount on the AR invoice to the JobCost distribution, there will remain a net Debit amount on the OE Clearing account. And when the bill has been posted in JobCost and the revenue recognized, the Revenue will have been posted to twice - once in OrderEntry and once in JobCost. The extra net Credit will be to Revenue, perhaps different accounts.

If you want to connect OE invoices to flow through JobCost, there has to be some creative setup to ensure all clearing accounts are netted to zero when the invoice has been posted everywhere. Perhaps this involves setting one of the Revenue accounts (either in JobCost jobs or IC items) to be the OE Clearing Account. Maybe journal entries need to be created in GL, by account reallocation or other methods. Perhaps others reading this have a better suggestion.

The obvious solution is for Softrak to integrate OrderEntry to JobCost. I can tell you that the day that's done I will have a large Adagio sale.

I know Softrak will say that the day that's done, OrderEntry will no longer be compatible with ACCPAC Plus Order Entry. Please tell me that OE 9.0A will contain the integration!

Steve