Average Cost/Purchase Order 1

[wwwedward]

7.5103f SQL Macola. Average cost is in use. Under average cost with inventory items, the purchase orders do not appear to pull average cost from the item file. Is the user required to enter the cost for each po line item??? I know under standard cost it would pull the standard cost from item location>...

 

[dgillz]

Actually the cost that is pulled for the PO is not controlled by the cost in use under IM setup but by a flag in PO Setup. The only valid choices are "Last" and "Standard". Average is not an option.

To set this option, go to PO, Maintain, PO Setup and set the "PO Entry Cost" to either Last or Standard.

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

http://www.trianglepartners.com

 

[wwwedward]

No &*(&#$*(, thanks.. So, we are using average but I cannot reflect that on the po side.. Strange. Sounds like last might eb the best option.. If u had average in inventory, waht would be your choice in po.??

Thanks for the help

 

[dgillz]

Do you hve Flexibility? If so it may be possible to pull in the average cost based on the gain_focus event. VBAjock or abaldwin would know better than me but it is worth taking a look at.

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

http://www.trianglepartners.com

 

[wwwedward]

No flex, at this time.

Thanks

 

[MacolaHelp]

If you start to use the po item vendor master file you can choose avg, last or std as the default cost code for a particular item for a particular vendor. You can build this file on the fly as you enter new purchase line items. You can also enter price breaks, etc. in this file. It's pretty powerful & can really help when you purchase the same item from multiple vendors.

 

[wwwedward]

Thanks all, Issue solved thanks to all of oyur help. PO should be last cost anyway most accurate for purchasing.