DOES ANYONE HAVE ANY SUGGESTIONS?

PROBLEM:

I have two types of items for sale, 1 is manufactured and the other is a purchased item which is just resold with a surcharge added on.

The problem being that integrations were mixed up!

The original plan was for the Manufactured item to flow through the Raw, WIP, Finished goods accounts, & the Purchased item to flow into a separate inventory called Resale Items

What has happened in realty is that under the purchase receipt integration it was actually mapped to the Raw inventory account, but under the Sales Issue integration it is correctly mapped to the Resale Items Inventory account.

Thus, I have a Raw Inventory account which is extremely overvalued and a Resale Items inventory account that is extremely undervalued.

Any ideas how I may be able to reconcile the 2 accounts such that I make a journal entery adjustment to properly adjust my balances.

I thought I might be able to find a unique identifier, dump data into excel, then manipulate it somehow.

So far no avail.

Hi -

Do your purchased items carry different cost price components than your manufactured items? If so, you could print your purchase/receipt integrations for your raw inventory account into excel, then sort on the cost price component.

Regards,
Linda

All but one cost price component is different.

This is the one I am most concerned about.

When cost items are received they appear in gld410 without warehouse. This is logic beacuase they are not kept in stock.
So if on one stock ledger account you want to filter out the cost items amount, do the following query on gld410
select amth
from baantfgld410
where tror = 1,
fitr = 2,
leac = the stock GL account you analyse,
cwar is empty.

Use dbcr to find out debited or credited amount with a decode function in an oracle SQL statement for instance.

You can also create an export scheme.

I think this will help you to retrieve the wrongly booked amount.

regards
JWLB:)