You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by cappa_feng <ca...@icloud.com> on 2019/07/04 15:40:57 UTC
COGS costing method is not supported
After creating Sales Order when I am going to Quick Ship Order, its showing
an error.
The Following Errors Occurred:
Error trying to begin transaction, could not process method: The current
transaction is marked for rollback, not beginning a new transaction and
aborting current operation; the rollbackOnly was caused by: Error in
simple-method [Create an accounting transactions for a sales shipment
issuance (D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT)
; [COGS costing method is not supported: ]
Please help me to solve this error.
--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Re: Fwd: COGS costing method is not supported
Posted by cappa_feng <ca...@icloud.com>.
Hi Paul,
thanks for your help.
The error is coming from there.
I have change the owner of the inventory to Company and then the owner is
the same as the party owner .
But i still got this issue.
Thanks.
--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Fwd: COGS costing method is not supported
Posted by Paul Foxworthy <pa...@cohsoft.com.au.INVALID>.
---------- Forwarded message ---------
From: Paul Foxworthy <pa...@cohsoft.com.au>
Date: Tue, 9 Jul 2019 at 10:44
Subject: Re: COGS costing method is not supported
To: cappa_feng <ca...@icloud.com>
Hi Cappa,
I believe the error is coming from here:
https://svn.apache.org/viewvc/ofbiz/ofbiz-framework/trunk/applications/accounting/minilang/ledger/GeneralLedgerServices.xml?revision=1858250&view=markup#l1116
The accounting preferences at that point are for the owner of the inventory
item, not necessarily Company. There is an example of a log message a few
lines earlier, on line 1065. You could add a new logging message at the
point the error occurs, and check which party is the owner. An easy way to
look at the OFBiz log is in the Web Tools:
https://demo-trunk.ofbiz.apache.org/webtools/control/LogView on the demo
site.
The owner is probably being set from the Owner of your facility. On the
demo site, at
https://demo-trunk.ofbiz.apache.org/facility/control/EditFacility you can
see that the owner is Company.
Hope that helps.
Cheers
Paul Foxworthy
On Mon, 8 Jul 2019 at 15:25, cappa_feng <ca...@icloud.com> wrote:
> Hi Paul ,
> i have checked my party accounting preferences and COGS is set there,
> and i also go to my web tools , the value of cogsMethodId for the party is
> COGS_FIFO .
> my set as below , Please suggest me some solution.
> <http://ofbiz.135035.n4.nabble.com/file/t369994/1562511139%281%29.jpg>
>
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
Re: COGS costing method is not supported
Posted by cappa_feng <ca...@icloud.com>.
Hi Paul ,
i have checked my party accounting preferences and COGS is set there,
and i also go to my web tools , the value of cogsMethodId for the party is
COGS_FIFO .
my set as below , Please suggest me some solution.
<http://ofbiz.135035.n4.nabble.com/file/t369994/1562511139%281%29.jpg>
--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Re: COGS costing method is not supported
Posted by Paul Foxworthy <pa...@cohsoft.com.au.INVALID>.
>
> Le 04/07/2019 à 17:40, cappa_feng a écrit :
> > After creating Sales Order when I am going to Quick Ship Order, its
> showing
> > an error.
> >
> > The Following Errors Occurred:
> > Error trying to begin transaction, could not process method: The current
> > transaction is marked for rollback, not beginning a new transaction and
> > aborting current operation; the rollbackOnly was caused by: Error in
> > simple-method [Create an accounting transactions for a sales shipment
> > issuance (D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT)
> >
> > ; [COGS costing method is not supported: ]
>
Hi Cappa,
Check your party accounting preferences.
On the demo site, at
https://demo-trunk.ofbiz.apache.org/accounting/control/AdminMain you can
see that the Cost Of Goods Sold (COGS) Method is LIFO. My guess is that
setting has not been entered for your organisation. More details here :
https://cwiki.apache.org/confluence/display/OFBENDUSER/12.1.1+Accounting+Preferences
.
COGS affects your accounting, so it's normally something you decide on once
when you create a party. If you have not yet entered any transactions, you
could change the setting in the Web Tools (
https://demo-trunk.ofbiz.apache.org/webtools/control/ViewGeneric?entityName=PartyAcctgPreference&partyId=Company
).
Cheers
Paul Foxworthy
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
Re: COGS costing method is not supported
Posted by Jacques Le Roux <ja...@les7arts.com>.
Le 04/07/2019 à 17:40, cappa_feng a écrit :
> After creating Sales Order when I am going to Quick Ship Order, its showing
> an error.
>
> The Following Errors Occurred:
> Error trying to begin transaction, could not process method: The current
> transaction is marked for rollback, not beginning a new transaction and
> aborting current operation; the rollbackOnly was caused by: Error in
> simple-method [Create an accounting transactions for a sales shipment
> issuance (D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT)
>
> ; [COGS costing method is not supported: ]
>
> Please help me to solve this error.
>
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
Hi,
Your message has been moderated.
Please subscribe to the user ML for such questions and then use your email client
See also why here http://ofbiz.apache.org/mailing-lists.html
You will get a better support , it's more fair to share with everybody and people can answer you on the ML rather than directly to you
The wider the audience the better the answers you might get
Also it's more work for moderators who have to accept your messages as long as you have not subscribed.
I'll personally no longer accept them (other moderators still could)
This said, did you customise the code or the data (particularly see[1]) , can you reproduce the same on the trunk demo?
[1] https://demo-trunk.ofbiz.apache.org/webtools/control/FindGeneric?entityName=PartyAcctgPreference
Thanks
Jacques