Hi Vaibhav, Thank you for providing the entity. When looking at the demo data in demo-trunk I don't see anything that relates back to an order. Maybe that is an incompleteness regarding the demo data....
I wonder which of the Financial Transaction related screens and services work with the orderId field. And I suggest that you bring forward how/when/where (use cases/user stories) a shipment to a customer or from a supplier or receiving the goods returned or sending goods back to a supplier lead to a financial transaction other than through banking or cash transaction (as a result of an order or RMA leading to a invoice or a credit note). Best regards, Pierre Smits ORRTIZ.COM <http://www.orrtiz.com> OFBiz based solutions & services OEM - The OFBiz Extensions Marketplace1 http://oem.ofbizci.net/oci-2/ 1 not affiliated to (and not endorsed by) the OFBiz project On Mon, Nov 20, 2017 at 3:16 PM, Vaibhav Jain < vaibhav.j...@hotwaxsystems.com> wrote: > Hello Pierre, > > For reference, > In inventoryItemDetail entity, we are recording orderId, returnId and > shipmentId to track the transaction of inventory item. > > Comments Inline > > Grin. I indeed must have overlooked something. > > > > So the orderId field is present in that entity. With that we can derive > > anything related, including shipments, returns, invoices, return > shipments, > > etc. > > > Yes we can derive all the related shipment, return, invoices and return > Shipment from the order id but it is not recorded at financial transaction > level which create a gap that why this transaction happen. We should record > this type of references on transaction level. > > > > > If we're going to include the fields you suggest, I surmise that before > > long someone else comes along with another addition he/she finds > convenient > > to have in that table. As the name of the entity suggest. This is about > > Financial Transactions (meaning cashflow related), not generic accounting > > transactions related. > > > > Yes, FinancialAccountTrans entity is used to record the financial > transaction(Cashflow related) of any party. And in OFBiz > financial transaction may be generated by various operations like Order, > Shipment and Return e.t.c. So we should have information like why this > transaction happens. > > WDYT? > > > > Best regards, > > > > Pierre Smits > > > > ORRTIZ.COM <http://www.orrtiz.com> > > OFBiz based solutions & services > > > > OEM - The OFBiz Extensions Marketplace1 > > http://oem.ofbizci.net/oci-2/ > > 1 not affiliated to (and not endorsed by) the OFBiz project > > > > On Mon, Nov 20, 2017 at 2:25 PM, Vaibhav Jain < > > vaibhav.j...@hotwaxsystems.com> wrote: > > > > > Hello Pierre, > > > > > > I am talking about OFBiz trunk. > > > > > > Here is the path of the file: > > > applications/datamodel/entitydef/accounting-entitymodel.xml:462 > > > > > > Just for more information, you can directly access this entity from > > > entityengine > > > https://demo-trunk.ofbiz.apache.org/webtools/control/ > > > FindGeneric?entityName=FinAccountTrans > > > > > > Thanks & Regards > > > > > > Vaibhav Jain > > > Hotwax Systems, > > > vaibhav.j...@hotwaxsystems.com > > > > > > On Mon, Nov 20, 2017 at 6:35 PM, Pierre Smits <pierre.sm...@gmail.com> > > > wrote: > > > > > > > Hi Valibhav, > > > > > > > > Which version of OFBiz are you talking about? I looked in data > > > > model.entitydef.accounting-entitymodel.xml and this entity did not > > show > > > > up. > > > > I may be overlooking something.. > > > > > > > > Best regards, > > > > > > > > > > > > > > > > Pierre Smits > > > > > > > > ORRTIZ.COM <http://www.orrtiz.com> > > > > OFBiz based solutions & services > > > > > > > > OEM - The OFBiz Extensions Marketplace1 > > > > http://oem.ofbizci.net/oci-2/ > > > > 1 not affiliated to (and not endorsed by) the OFBiz project > > > > > > > > On Mon, Nov 20, 2017 at 1:41 PM, Vaibhav Jain < > > > > vaibhav.j...@hotwaxsystems.com> wrote: > > > > > > > > > Hello all, > > > > > > > > > > Currently, orderId field is available and returnId, shipmentId > fields > > > can > > > > > be introduced in the FinAccountTrans entity. > > > > > > > > > > These fields are useful while recording fin account transactions. > > > > > > > > > > Please let me know your thoughts on it. > > > > > > > > > > Thanks in advance > > > > > > > > > > Vaibhav Jain > > > > > Hotwax Systems, > > > > > vaibhav.j...@hotwaxsystems.com > > > > > > > > > > > > > > >