Almyta Systems Homepage
Forum Home Forum HomeSBS and AID Software packagesSBS/AID Inventory Control
  New Posts New Posts RSS Feed - negative adjustment cannot be imported
  FAQ FAQ  Forum Search   Register Register  Login Login

This site is dedicated to Almyta Systems Inventory Software

negative adjustment cannot be imported

 Post Reply Post Reply
Author
Message
BGSTRADING View Drop Down
Newbie
Newbie


Joined: 21 Feb 2014
Location: SINGAPORE
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote BGSTRADING Quote  Post ReplyReply Direct Link To This Post Topic: negative adjustment cannot be imported
    Posted: 13 Mar 2014 at 1:44am
I was trying to import the negative adjustment and have Error #2200

After filling up the filled , it started the importing but after it is completed , it say Zero record imported.

And have the following message :

Some Transactions have been skipped ,use the SAVE imported data button again to import skipped transactions.

I hit the button a few time , still Zero record imported

Any solution to this
Back to Top
Debra View Drop Down
Senior Member
Senior Member


Joined: 22 Aug 2011
Points: 535
Post Options Post Options   Thanks (0) Thanks(0)   Quote Debra Quote  Post ReplyReply Direct Link To This Post Posted: 13 Mar 2014 at 4:37pm

Did you use LDX10 device to import negative adjustments? The records left on screen are the ones that could not be processed. Usually you can take a look and see what is wrong. Can you post one such record here (comma separated)?

Back to Top
BGSTRADING View Drop Down
Newbie
Newbie


Joined: 21 Feb 2014
Location: SINGAPORE
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote BGSTRADING Quote  Post ReplyReply Direct Link To This Post Posted: 14 Mar 2014 at 6:22am

I HAVE THE FOLLOWING :

Item Id
Location
Qty Reduce eg 5 pcs used , my spreadsheet has a no 5 ( no negative sign)

Date :
Location
Back to Top
BGSTRADING View Drop Down
Newbie
Newbie


Joined: 21 Feb 2014
Location: SINGAPORE
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote BGSTRADING Quote  Post ReplyReply Direct Link To This Post Posted: 17 Mar 2014 at 8:59am
hi

THIS ARE ITEM LEFT BEHIND WHEN I TRY IMPORT NEGATIVE ADJUSTMENT

ITEM ID            QTY     NEGATIVE ADJUST     BAL UNIT     LOCATION
T61604-47090     10     -4               6                 42
T61602-47091     10     -7               3                 42
Back to Top
Debra View Drop Down
Senior Member
Senior Member


Joined: 22 Aug 2011
Points: 535
Post Options Post Options   Thanks (0) Thanks(0)   Quote Debra Quote  Post ReplyReply Direct Link To This Post Posted: 18 Mar 2014 at 6:35am

You did not answer if it was LDX10, but I assume that you used "LDX10: Negative Adjustments" transaction. Here are the formats for LDX-10 transactions:

Transaction Type (Mandatory),Transaction Reference,ITEM ID or UPC CODE,Quantity,Source Location,Destination Location,Serial 1,Serial 2,exp Date,prod Date

Transaction Types: 
P - positive adjustment, C - count, M - move, N - negative adjustment,

Field Sizes:
1,0-20 alphanumeric,0-50 alphanumeric,positive number,0-255 alphanumeric,0-255 alphanumeric,0-50 alphanumeric,0-50 alphanumeric,MM/DD/YYYY,MM/DD/YYYY

Sample positive adjustment:

mandatory,optional,mandatory,mandatory,empty,optional,optional,optional,optional,optional

P,PO1234,PART3124,12,,LOCATION1,SN12345,SNT12345,12/31/2013,12/30/2013
P,PO1234,PART3124,1,,,,,,
P,,PART3124,1,,,,,,

Sample negative adjustment:

mandatory,optional,mandatory,mandatory,empty,optional,optional,optional,empty,empty

N,SO1234,PART3124,12,,LOCATION1,SN12345,,,
N,SO1234,PART3124,1,,LOCATION2,SN12345,SNT12345,,
N,,PART3124,1,,,,SNT12345,,

Sample Move:

mandatory, empty,mandatory,optional,optional,mandatory,optional,optional,empty,empty
M,,PART3124,12,LOC 1,LOC 2,SN12345,SNT12345,,

Sample Count:

mandatory, empty,mandatory,mandatory,mandatory,empty,optional,empty,empty,empty

C,,PART3124,12,LOC 1,,SN12345,,,



Back to Top
BGSTRADING View Drop Down
Newbie
Newbie


Joined: 21 Feb 2014
Location: SINGAPORE
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote BGSTRADING Quote  Post ReplyReply Direct Link To This Post Posted: 25 Mar 2014 at 3:32am
Hi

Thank you for the help , yes manage to solve the issue with the help

Back to Top
Mkoehler View Drop Down
Newbie
Newbie


Joined: 29 Jul 2014
Location: Bay Area CA
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mkoehler Quote  Post ReplyReply Direct Link To This Post Posted: 29 Jul 2014 at 1:44pm
Hi This thread has been quite useful so far, but I do have an additional question.

I have tested the negative adjustment import (LDX10) and it works to adjust the inventory stock down, but I cannot seem to include a customer for the items shipped out. What I usually do is manually adjust down inventory when it is shipped to a customer. Can I include customer information when importing negative adjustments?

Thanks so much!

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10
Copyright ©2001-2011 Web Wiz Ltd.

This page was generated in 0.125 seconds.