ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Clark <rip...@gmail.com>
Subject Re: automation of inventory receive process simliar to import of external data
Date Mon, 20 Apr 2015 05:34:53 GMT
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 <rip057@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.cappellato@hotwaxsystems.com> wrote:
>
>>
>> On Apr 9, 2015, at 2:38 PM, Chris Clark <rip057@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=10000, productId=abc100,
>> datetimeReceived=2015-04-13
>> InventoryItemDetail: inventoryItemId=10000,
>> 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.cappellato@hotwaxsystems.com> wrote:
>> >
>> >> Hi Chris,
>> >>
>> >> please see inline:
>> >>
>> >> On Apr 9, 2015, at 1:16 PM, Chris Clark <rip057@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 <rip057@gmail.com>
>> wrote:
>> >>>
>> >>>> is there a way for me to import an xml file in a similiar fashion
to
>> the
>> >>>> way i can import products from an external database to increase
the
>> >>>> inventory count...  you may have seen my previous question about
how
>> to
>> >>>> mass import pictures...  I have figured that out with a script that
>> >>>> combines the functionality of imagemajicks convert function, used
>> >> through a
>> >>>> system call from gawk, multiplied over the various picture sizes,
>> and a
>> >>>> simple text file that enumerated what each picture's associated
>> >> productid
>> >>>> was in a line delimited fashion...
>> >>>>
>> >>>> I like running a simple text file through a script to automate these
>> >> ofbiz
>> >>>> functions as a much simpler way to do batch processing of jobs that
>> >> already
>> >>>> are a bit of a task, but having to go into each item and recieve
>> >>>> inventory... well.... i refurb printers and everyone that i strip
>> apart
>> >>>> yields about 20-40 parts... multiply that over approximately 20
>> >> printers a
>> >>>> pallet... you get the idea i would ideally have a line delimited
or
>> csv
>> >>>> delimited file that can be processed by gawk into an xml file that
i
>> >> can do
>> >>>> the load-extdata call from ant with
>> >>>>
>> >>>> could i just create a ShipmentReceipt.xml and load that... it just
>> seems
>> >>>> like that is a marking of the transaction and not the transaction
>> >>>>
>> >>
>> >>
>>
>>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message