|
Inventory Adjustment |
Post Reply 
|
| Author |
 Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search  Topic Options
|
administrator 
Admin Group 
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
 Post Options
 Quote Reply
 Topic: Inventory AdjustmentPosted: 02 July 2010 at 1:34pm |
|
Please try this build: http://bscdownload.com/downloads/special/TPI4015aPR.zip
|
|
 |
|
|
tomsisum
Groupie 
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 30 June 2010 at 3:33pm |
|
correct
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 30 June 2010 at 2:50pm |
|
So if New Qty = 0 then no adjustment is made and it is basically ignored?
|
|
|
|
|
tomsisum
Groupie
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 30 June 2010 at 2:13pm |
|
Okay, I have found the pattern. It is not adjusting the on hand figure when the figure being imported is 0. For example, if the figure in QB prior to the adjustment is 15, nd the new qty figureI imort is 0, the qb figure remains 15. All other numbers work (so, e.g., qb hd 15, the new qty figure in the import is 10, and then after the import qb reads 10).
This feels solveable!
Tom
|
|
|
|
|
tomsisum
Groupie
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 30 June 2010 at 12:56pm |
|
Thee is no pattern to the ones not being adjusted. They are in the same fomat as the ones which are being done, using the new qty filed. They are not at the end or the begnning of the list. So I ca't figure out what's up.
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 30 June 2010 at 6:58am |
|
Which ones are not being adjusted? Are you using the "New Qty" fields for those?
|
|
|
|
|
tomsisum
Groupie
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 29 June 2010 at 6:37pm |
|
Hi There Just been testing. Its an improvement, in that it seems to be making the adjustment versus the correct date in the past. However I am getting uneven results - 90% of items are being adjusted, 10% not. I have tried rerunning several times but get the same results.
Thoughts??
Tom
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 29 June 2010 at 11:45am |
|
Please try this pre-release build and see if it resolves your issue.
Install it over your existing build.
|
|
|
|
|
tomsisum
Groupie
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 29 June 2010 at 9:52am |
|
That would be outstanding. Would you like me to email you separately? Regards
Tom
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 29 June 2010 at 8:29am |
|
OK, we understand what is happening now. We will have to make some adjustments to address this issue. It might take as long as a week to get you a build that addresses this.
|
|
|
|
|
tomsisum
Groupie
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 28 June 2010 at 5:32pm |
|
Yes, I have tested it manually. I have also looked at what TPI produces when I run it. It creates an inventory adjustment with the date (in the past) I want, but it translates the new qty figures I enter into qty adjustment figures, but using the on hand figures for the present date. For example,
1 Mar 1 Apr 1 May
1 2 7
If I wanted to adjust the figures for 1 April from 1 to 2, but the current on hand figure (assuming I did te adjustment on 1 May) was 5, TPI translates my '2' to be a qty adjustment of '-5' (7-2=5).
Any ideas? Perhaps you could recreate and see what you think is going on?
Any help gratefullyreceived.
Tom
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 28 June 2010 at 9:23am |
|
Can you do what you are saying manually in QB?
|
|
|
|
|
tomsisum
Groupie
Joined: 26 February 2010 Online Status: Offline Posts: 11 |
Post Options
Quote Reply
Posted: 28 June 2010 at 8:22am |
|
Hi There,
I am having problems doing an inventory adjustment using TPI 4.
I need to adjust quantities on hand for a point in the past. TPI lets me input the date of the transaction, and the 'new qty' for each item. However, after I run the import and look at QB what I see is that TPI has imported in such a way tht QB has compared the 'new qty' numbers I imported to the qty on hand for today's date, not the date of the transaction. Confusingly the adjustment date shown in QB (created during the import) is the date I selected in the past.
Am I missing something?
Many thanks
Tom
|
|
|
|
|
Post Reply
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
