530
I have an item with zero inventory and zero cost but a negative value in three different locations. Drop, warehouse and office. How do I eliminate the negative values in the item journal or revaluation journal? I am on the average costing method.
*This post is locked for comments
the qty is zero with negative value. No I am not using Put away.
You can consider posting a positive adjustment in item journal for the location where it is showing negative quantity with value as zero.
Are you using Directed Put Away & Pick on the location where you have negative quantity? If so, you will have to use warehouse item journal.
Krupesh
[quote user="Peter Irwin"]
item is finished good...
[/quote]
Pleas check the next:
-whether all the Production Orders for this item are finished
-whether all the components on these Production Orders are invoiced on Purchase Invoice
I will send object to your mail.
I'm not sure about correctness od these informations from your report. I don't know what customization of report is it.
Because of that, I like to get information with standard report.
If you are not comfortable with objects, please export to Excel all Value Entries and Item Ledger Entries related to this item and send it on my mail:
aleksandar.totovic@nps.rs
item is finished good. Have no use for the item anymore. It is zero inventory and zero cost. I have purchase documents and item charges. shipping from 2 locations as well as drop shipments
my address is : peter.irwin@irwintoy.com. I think this is getting too complex for me. I am not that comfortable. Is there an easier way to do this?
No where do I find this? It maybe out of my comfort zone
What is your item, material or finish-good? What is type of inbound documents?
If you have not field 'Include expected cost', that this is modified object. In standard report, there are not exist vatiant, location and detail fields on option tab.
I will send you in mail attachment standard report. What is your mail?
Try to import this report to your database and run them. Please, first make backup of your current object as fob.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (