ok so after many many hours and many many trials and errors... i finally
have an inventory import process that is including my image import process
and the only thing needed for input is ONE very small csv file, and other
files that are generated automatically from said csv file so i am happy...
this will save my fingers and wrists countless pains through automation
I wanted to include shipment receipt along with the item id and and item id
details so i could see the various lots that i was adding of the incoming
parts into the database
fwiw the order for just those three ids is
InventoryItem
ShipmentReceipt
InventoryItemDetail
it must go in that way because of the key structure? idk but where can i
look, i.e. what folder would kind of give me an idea of that tree
structure, because i have an idea i will want to start including other
things and it was pita to figure out that i couldnt have the same
inventoryid twice but i could have the same receiptid as many times as i
wanted, im sure there was some glorious reasoning for that, and maybe if i
actually read the code i could semi understand it, but where could i go for
a hint as to what some of the constraints are... or is this just a trial
and error sort of thing
thanks again
Chris
On Thu, Apr 9, 2015 at 4:53 PM, Chris Clark rip...@gmail.com wrote:
i do get an invalid error or a long error that references the recieptId
being invalid
On Thu, Apr 9, 2015 at 4:16 PM, Jacopo Cappellato
jacopo.cappell...@hotwaxsystems.com wrote:
On Apr 9, 2015, at 2:38 PM, Chris Clark rip...@gmail.com wrote:
so for instance if i strip down for parts a model abc
and end up with parts (product ids)
abc100 abc120 (20 parts total)
and assume i only want to deal with inventory for now, and not for
accounting (although i presume i am going to need to address the
accounting), then correct me if i am wrong
I do NOT have to create a shipmentreceipt
ONE new inventory item for EACH part #
also ONE new inventoryitemdetail for each part#?
Correct: if you only want to deal with inventory, you can create one new
inventory item and one new inventory item detail for each part# every time
you receive it.
For example, if you receive 10 units of abc100 on 2015-04-13 then you
will create
InventoryItem: inventoryItemId=1, productId=abc100,
datetimeReceived=2015-04-13
InventoryItemDetail: inventoryItemId=1,
inventoryItemDetailSeqId=0001, quantityOnHandDiff=10,
availableToPromiseDiff=10
Then, when you receive 20 units of the same product on 2015-04-15 then
you will create similarly:
InventoryItem: inventoryItemId=10001, productId=abc100,
datetimeReceived=2015-04-15
InventoryItemDetail: inventoryItemId=10001,
inventoryItemDetailSeqId=0001, quantityOnHandDiff=20,
availableToPromiseDiff=20
fwiw from what i have experienced with trial and error i have to create
a
new AcctgTrans in order to even create a new ShipmentReceipt (receiptId)
entry
This shouldn't be the case but let me know if you get this error again.
Regards,
Jacopo
this is all new to me, but i have to say the ability to integrate this
into
what i would call shell transactions is awesome as it allows us to
forego
the gui and the repetitive movements that plague all us computer users
On Thu, Apr 9, 2015 at 3:18 PM, Jacopo Cappellato
jacopo.cappell...@hotwaxsystems.com wrote:
Hi Chris,
please see inline:
On Apr 9, 2015, at 1:16 PM, Chris Clark rip...@gmail.com wrote:
ive actually answered my own question... sort of... the key files that
are
of importance from my research are
AcctgTrans.xml
AcctgTransEntry.xml
the above two entries are about General Ledger accounting transaction:
AcctgTrans is the header and AcctgTransEntry are the Dr and Cr
entries; if
you are not planning to use accounting you could even skip them.
ShipmentReceipt.xml
This represent the document for the receipt; the GL transactions are
associated to this document.
InventoryItem.xml
and last but not least
InventoryItemDetail.xml
You should create one new InventoryItem for each ShipmentReceipt; then
you
should also create the InventoryItemDetail with the initial units
received;
this will trigger a service that will update the
InventoryItem.quantityOnHandTotal field.
I hope it helps,
Jacopo
the first three are for the creation of the shipment transaction
receipt?
im a little confused on this, but i know i cant add to the
shipmentreceipt
without creating the receiptid in acctgtrans, and im not sure about
the
acctgtransentry entries, if anyone can help please do...
the latter two are specifically what i am more concerned with and
that is
the on hand amount of each part, but is the acctg and ship receipt
necessary to just modify the on hand for the web store?
any help on this is greatly appreciated
Chris
On Thu, Apr 9, 2015 at 11:35 AM, Chris Clark rip...@gmail.com
wrote: