Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Posting Credit Invoice to Alternate GL Account
- Thread starter rustylee
- Start date
Are you looking to put the credits into a different AR account or Sales Account. You could handle the sales by product category / location in OE, Maintain. However, you would need to use a specific item that was mapped correctly. I don't think there's a way to use the same product codes but map them to different accounts whether they were on an Invoice or Credit Memo.
Kevin Scheeler
Kevin Scheeler
- Thread starter
- #3
Hi kscheeler,
I think you understand my question, but that won't work because, as you rightly pointed out, the product category cannot be changed in the order. Too bad. That would have worked nicely.
Any Flex hackers out there have any suggestions? Could the data be changed in the order before postings that would effectively do the same thing?
I think you understand my question, but that won't work because, as you rightly pointed out, the product category cannot be changed in the order. Too bad. That would have worked nicely.
Any Flex hackers out there have any suggestions? Could the data be changed in the order before postings that would effectively do the same thing?
If you're only looking to put all of the credits into one GL account, I would run a report at the end of the month and do a GL entry for it. If it's much more than that, you can look at changing the prod_cat field in the OEORDLIN table after the line was saved. I believe it uses this field during the posting process to get the correct GL account.
Kevin Scheeler
Kevin Scheeler
MacolaHelp
Instructor
If you are not using profit center accounting in OE setup, the product category is used if you have a product category/location record in place. If not, it uses the defaults in OE. If you copied these items to a new location, you could change the GL accounts in the new location to reflect your GL preference, process the credit. If the item is returned to inventory when credited, you could then transfer back to the primary warehouse to be reissued to get the correct accounting for a resale.
If you use profit center in OE setup, the customer types drive the GL accounting in combination w/the categories.
You might also have a miscellaneous item called "returns", specify in the description or comments what is returned & tie item master that to a specific prod cat/loc GL account record.
The allowances account in AR cust type maintainence is used for CR processing when you write off differences between the invoice & the customer payment. OE doesn't use these fields for credits.
I'd be hesitant to change the categories once in OEORDLIN without extensive testing to find out what other reports, etc might be affected by changing a category in the line file so it no longer matches the item master & inventory location records. I've seen several clients down for days when the categories don't match between the master & location records. However, the PC is captured at the point of order entry, so it wouldn't be dynamically updated when item master is changed & the product is already on order. Might be worth the trouble of testing all the reports tied to product category. There are a lot of reports that are tied to product category throughout the distribution files, so you should look at them all before you alter the files externally.
If you use profit center in OE setup, the customer types drive the GL accounting in combination w/the categories.
You might also have a miscellaneous item called "returns", specify in the description or comments what is returned & tie item master that to a specific prod cat/loc GL account record.
The allowances account in AR cust type maintainence is used for CR processing when you write off differences between the invoice & the customer payment. OE doesn't use these fields for credits.
I'd be hesitant to change the categories once in OEORDLIN without extensive testing to find out what other reports, etc might be affected by changing a category in the line file so it no longer matches the item master & inventory location records. I've seen several clients down for days when the categories don't match between the master & location records. However, the PC is captured at the point of order entry, so it wouldn't be dynamically updated when item master is changed & the product is already on order. Might be worth the trouble of testing all the reports tied to product category. There are a lot of reports that are tied to product category throughout the distribution files, so you should look at them all before you alter the files externally.
The product category in the OE Order line table does not have to match the Item Master. When you change the Item Master, it only changes the same field in the Item Location table. The sales analysis reports in OE, Reports pull from the ptd/ytd fields from the Item Location tables. The sales comparison reports show the comparison based on the salesman, customer, item, ship to and product category at the time of the sale.
Kevin Scheeler
Kevin Scheeler
MacolaHelp
Instructor
It is possible to get "out of sync" between the order line & item/master location files by changing a product category in the master after already on a sales order. The OE sales analysis reports look at item master & location files, so reconciling these to GL accts whose product categories were changed before posting is difficult.
The sales comparison reports use OESLSHST, which is updated at the time of sales history posting & use the product category in the order line file at the time of posting. You would not be able to reconcile the analysis reports to the comparison reports by changing categories externally, but you could reconcile to your general ledger.
Since I have an accounting background, my preference is to have the reports tie out to the GL & each other. If that is not a consideration for this client, by all means, modify away externally. However, if you find a way to do it inside Macola (such as new location for credits & transfer back reusable inventory), it preserves the integrity of the accounting that is all done "behind the scenes".
Maybe a good flex thought would be to pop up the category at the point of line item entry, so it could be changed. That would still create an imbalance between sales analysis & comparison reports, but maybe not enough of a material difference to worry about . . .
The sales comparison reports use OESLSHST, which is updated at the time of sales history posting & use the product category in the order line file at the time of posting. You would not be able to reconcile the analysis reports to the comparison reports by changing categories externally, but you could reconcile to your general ledger.
Since I have an accounting background, my preference is to have the reports tie out to the GL & each other. If that is not a consideration for this client, by all means, modify away externally. However, if you find a way to do it inside Macola (such as new location for credits & transfer back reusable inventory), it preserves the integrity of the accounting that is all done "behind the scenes".
Maybe a good flex thought would be to pop up the category at the point of line item entry, so it could be changed. That would still create an imbalance between sales analysis & comparison reports, but maybe not enough of a material difference to worry about . . .
- Status
Similar threads