PO Module - Progression 7.6.4 SPB

[dmrVA]

A few months ago we added the PO module. Our business partner came and set it up, but we now found because of how our business is and the program is, we have created a lot of work for ourselves.

Example. We have two departments and we have our accounts set up so that the income statements will print for each department plus combined. We have found that the PO Module only allows us one cost variance account. So at month end I have to reclass what hits the PPV account to the correct departments. Also, there is only one freight account in AP. Before we just added a freight line, with the PO Module we were trying to use the freight field, but it hits raw materials, the default freight account.

For those of you who have been using the PO Module, have you figured out work-a-rounds for these? I'm sure more companies that us need the ability to allocate to departments. At this point, we are ready to trash the module because it is just costing us too much in labor to analyze the accounts and reclass at the end of the month.

Thanks

Donna

 

[ultrav]

I am confused because we have 7.6.3c and we have the ability to change the default PPV and cost variance account on each line item - we can also assign default PPV/cost variance accounts to Material cost types/LOC combinations. Do you have Inventory Management? The default variance accounts can be added to Material Cost Type/Loc through Inventory Management Maintenance.

Celeste

 

[dmrVA]

Yes, we have Inventory Management. According to Exact, it uses this at the time of voucher. But at the time of creating the PO, it uses the default account in the PO setup. So any rec'd, unvouchered for our CM department hits the ledger as department 4015-00 (our IN dept) istead of 4015-03. So I have to do review the account and do reversing entries each month.

Thanks
Donna

 

[dgillz]

For the benefit of those that may have some ideas, the issue here is that there is only one PPV Suspense account in PO setup. If there was one PPV Suspense per each material cost type/location record, the problem would be solved.

As it now stands, ALL PPV Suspense regardless of product line is going to the same account, the one in PO Setup. This makes it very difficult to get profitability by product line.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[kstickler]

Is there a field on the PO that would identify the specific department? If so, you could write a sql trigger to change the account number to the correct one when the PO record is added to the table.

 

[dgillz]

Kstickler,

I like your thinking, however this a Pervasive user. If you know how to do this in Pervasive please let me know.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[dmrVA]

The PO Module does a good job of writing to the ledger. It actually has the part# in the reference field and I use that to determine what to reclass. However, anything that cannot be automated, just adds an administrative cost that ultimately hits the product cost.

Thanks for the ideas.