COGS costing method is not supported

[cappa_feng]

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

[Jacques Le Roux]

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

[Paul Foxworthy-2]

>
> 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: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]

[cappa_feng]

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

[Paul Foxworthy-2]

---------- Forwarded message ---------
From: Paul Foxworthy <[hidden email]>
Date: Tue, 9 Jul 2019 at 10:44
Subject: Re: COGS costing method is not supported
To: cappa_feng <[hidden email]>


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 <[hidden email]> 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: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]


--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]

[cappa_feng]

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