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 Thu, 09 Apr 2015 21:53:35 GMT
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