COGS costing method is not supported Error

[shwetacf]

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)
[file:/home/ec2-user/apache-ofbiz-13.07/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]:
; [COGS costing method is not supported: ]

Please help me to solve this error.





Thanks
Shweta

[Paul Foxworthy]

Hi Shweta,

Check your COGS method. Go to Applications-Accounting-Organization GL
Settings (/accounting/control/AdminMain?organizationPartyId=Company) .
Click on Setup. The Cost Of Goods Sold (COGS) method should be displayed
there. If it's blank, that would explain your problem.

You should set it during initial configuration of OFBiz.

Cheers

Paul Foxworthy


On 4 January 2017 at 17:34, Shweta Agrawal <[hidden email]> wrote:

> 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)
> [file:/home/ec2-user/apache-ofbiz-13.07/applications/
> accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#
> createAcctgTransForSalesShipmentIssuance]]:
> ; [COGS costing method is not supported: ]
>
> Please help me to solve this error.
>
>
>
>
>
> Thanks
> Shweta
>

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

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

[shwetacf]

I have checked there and COGS is set there.



Thanks
Shweta

[Paul Foxworthy]

Hi Shweta,

OK. Let's see the exact value of the field.

In Web Tools, go to Entity Data Maintenance, find the PartyAcctgPreferences
entity, then click on All beside it.
(/webtools/control/FindGeneric?entityName=PartyAcctgPreference&find=true&VIEW_SIZE=50&VIEW_INDEX=0)

What is the value of cogsMethodId for the party or parties?

Cheers

Paul Foxworthy



On 4 January 2017 at 19:00, shwetacf <[hidden email]> wrote:

> I have checked there and COGS is set there.
>
>
>
> Thanks
> Shweta
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700830.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

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

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

[shwetacf]

cogsMethodId COGS_FIFO
And also I created one store from that store I am ordering the product. Is there some configuration required to that store?


Thanks
Shweta

[Paul Foxworthy]

Hi Shweta,

COGS Method is an accounting decision that applies to your organization as
a whole. I don't think there's anything necessary for a product store.

Very strange, "COGS_FIFO" is a valid value for COGS method. The code at
http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/minilang/ledger/GeneralLedgerServices.xml?view=markup#l1093
is looking for that exact value. Maybe add a logging statement at that
point to see what you're getting?

Can you make the error happen consistently?

Cheers

Paul Foxworthy


On 5 January 2017 at 14:41, shwetacf <[hidden email]> wrote:

> cogsMethodId    COGS_FIFO
> And also I created one store from that store I am ordering the product. Is
> there some configuration required to that store?
>
>
> Thanks
> Shweta
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700845.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

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

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

[shwetacf]

Hi Paul,

I have created my own Warehouse through facility, When I am creating order using that warehouse then Error is coming. But if I use webstore Warehouse which is in demo data then I am not getting any Error.

And I have searched everywhere and checked the configuration of both warehouse, they were all same. But after all this I am getting this error.

Please suggest me some solution.


Thanks
Shweta

[Paul Foxworthy]

Hi Shweta,

I reckon there's a different party involved. So when the receive shipment
stuff tries to lookup the accounting preferences, it doesn't find any.

In the demo data, the owner of the WebStoreWarehouse is "Company" (see
/facility/control/main), and the accounting preferences can be found
at accounting/control/AdminMain?organizationPartyId=Company

If you have a different owner for the facility, you'll need to set up the
accounting preferences for that party.

Cheers

Paul Foxworthy





On 6 January 2017 at 15:27, shwetacf <[hidden email]> wrote:

> Hi Paul,
>
> I have created my own Warehouse through facility, When I am creating order
> using that warehouse then Error is coming. But if I use webstore Warehouse
> which is in demo data then I am not getting any Error.
>
> And I have searched everywhere and checked the configuration of both
> warehouse, they were all same. But after all this I am getting this error.
>
> Please suggest me some solution.
>
>
> Thanks
> Shweta
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700861.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

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

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

[shwetacf]

Hi Paul,

Yes, I know that owner should be Company. I did that. But after this also I am getting same error.


Thanks
Shweta

[Paul Foxworthy]

Hi Shweta,

Is the PartyAcctgPreference with COGS_FIFO for Company or a different Party?

Cheers

Paul Foxworthy

On 6 January 2017 at 19:01, shwetacf <[hidden email]> wrote:

> Hi Paul,
>
> Yes, I know that owner should be Company. I did that. But after this also I
> am getting same error.
>
>
> Thanks
> Shweta
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700863.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

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

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

[shwetacf]

It is for a company only. And the owner is Company.


Thanks
Shweta

[Paul Foxworthy]

Hi Shweta,

OK. Check the owners of the relevant inventory item or items. Are they
Company too, or another party without accounting prefs?

If that doesn't help, I suggest you add some logging
to applications/accounting/minilang/ledger/GeneralLedgerServices.xml to
discover the value of cogsMethodId.

So about here:

http://svn.apache.org/viewvc/ofbiz/trunk/applications/accounting/minilang/ledger/GeneralLedgerServices.xml?view=markup#l1054

after the party accounting preferense have been fetched, add a line like

<log level="error" message="Accounting prefs for party
${inventoryItem.ownerPartyId} has cogsMethodId of
${partyAcctgPreference.cogsMethodId}" />

Hope that helps.

Cheers

Paul



On 9 January 2017 at 14:46, shwetacf <[hidden email]> wrote:

> It is for a company only. And the owner is Company.
>
>
> Thanks
> Shweta
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.
> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700882.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

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

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

[Paul Foxworthy]

Hi Shweta,

Were you able to solve the problem?

Cheers

Paul Foxworthy

On 12 January 2017 at 17:02, Paul Foxworthy <[hidden email]> wrote:

> Hi Shweta,
>
> OK. Check the owners of the relevant inventory item or items. Are they
> Company too, or another party without accounting prefs?
>
> If that doesn't help, I suggest you add some logging
> to applications/accounting/minilang/ledger/GeneralLedgerServices.xml to
> discover the value of cogsMethodId.
>
> So about here:
>
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/
> accounting/minilang/ledger/GeneralLedgerServices.xml?view=markup#l1054
>
> after the party accounting preferense have been fetched, add a line like
>
> <log level="error" message="Accounting prefs for party
> ${inventoryItem.ownerPartyId} has cogsMethodId of ${partyAcctgPreference.cogsMethodId}"
> />
>
> Hope that helps.
>
> Cheers
>
> Paul
>
>
>
> On 9 January 2017 at 14:46, shwetacf <[hidden email]> wrote:
>
>> It is for a company only. And the owner is Company.
>>
>>
>> Thanks
>> Shweta
>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.
>> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700882.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: [phone] <+61%203%209585%206788>
> 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]

[Vaibhav Jain]

Hello Shweta,

Please check the records of "InventoryItem" entity for your sales order.

If "accountingQuantityTotal"  field is *ZERO *for respective inventory item
then it will throw this error.

Why?

Because, at the time of item issuances, GL postings are done in "
*INVENTORY_ACCOUNT*" account. And system takes "accountingQuantityTotal"
into consideration to calculate postings to be done in "INVENTORY_ACCOUNT".
And when system gets accountingQuantityTotal = 0, it returns error.

Thanks & Regards
--

Vaibhav Jain
Hotwax Systems,
[hidden email]

On Thu, Feb 16, 2017 at 10:52 AM, Paul Foxworthy <[hidden email]>
wrote:

> Hi Shweta,
>
> Were you able to solve the problem?
>
> Cheers
>
> Paul Foxworthy
>
> On 12 January 2017 at 17:02, Paul Foxworthy <[hidden email]> wrote:
>
> > Hi Shweta,
> >
> > OK. Check the owners of the relevant inventory item or items. Are they
> > Company too, or another party without accounting prefs?
> >
> > If that doesn't help, I suggest you add some logging
> > to applications/accounting/minilang/ledger/GeneralLedgerServices.xml to
> > discover the value of cogsMethodId.
> >
> > So about here:
> >
> > http://svn.apache.org/viewvc/ofbiz/trunk/applications/
> > accounting/minilang/ledger/GeneralLedgerServices.xml?view=markup#l1054
> >
> > after the party accounting preferense have been fetched, add a line like
> >
> > <log level="error" message="Accounting prefs for party
> > ${inventoryItem.ownerPartyId} has cogsMethodId of ${partyAcctgPreference.
> cogsMethodId}"
> > />
> >
> > Hope that helps.
> >
> > Cheers
> >
> > Paul
> >
> >
> >
> > On 9 January 2017 at 14:46, shwetacf <[hidden email]> wrote:
> >
> >> It is for a company only. And the owner is Company.
> >>
> >>
> >> Thanks
> >> Shweta
> >>
> >>
> >>
> >> --
> >> View this message in context: http://ofbiz.135035.n4.nabble.
> >> com/COGS-costing-method-is-not-supported-Error-tp4700827p4700882.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >
> >
> >
> > --
> > Coherent Software Australia Pty Ltd
> > PO Box 2773
> > Cheltenham Vic 3192
> > Australia
> >
> > Phone: [phone] <+61%203%209585%206788>
> > 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]
>

[vinodpavan2k13]

Hi Paul,

 I have tried as the same what you have suggested to set a log line in the
XML file but I am unable to the LOG can you please help in finding the log.

Thanks & Regards,
Vinod Kumar



--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

[Deepak Dixit-4]

Hi Vinod,

Your email has been moderated, Please subscribe mailing list

> http://ofbiz.apache.org/mailing-lists.html


Thanks & Regards
--
Deepak Dixit


On Thu, Oct 4, 2018 at 12:17 PM, vinodpavan2k13 <[hidden email]>
wrote:

> Hi Paul,
>
>  I have tried as the same what you have suggested to set a log line in the
> XML file but I am unable to the LOG can you please help in finding the log.
>
> Thanks & Regards,
> Vinod Kumar
>
>
>
> --
> Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
>

[Pritam Kute]

Hi Vinod,

Generally, logs can be seen on the OFBiz console. If not, you can go to
webtools -> View Logs menu.

https://demo-trunk.ofbiz.apache.org/webtools/control/LogView

Please make sure proper log configurations are done at webtools -> View
Logs -> Log Configurations.

Hope this helps

Thanks and Regards
--
Pritam Kute


On Thu, Oct 4, 2018 at 1:34 PM Deepak Dixit <[hidden email]> wrote:

> Hi Vinod,
>
> Your email has been moderated, Please subscribe mailing list
>
> > http://ofbiz.apache.org/mailing-lists.html
>
>
> Thanks & Regards
> --
> Deepak Dixit
>
>
> On Thu, Oct 4, 2018 at 12:17 PM, vinodpavan2k13 <[hidden email]>
> wrote:
>
> > Hi Paul,
> >
> >  I have tried as the same what you have suggested to set a log line in
> the
> > XML file but I am unable to the LOG can you please help in finding the
> log.
> >
> > Thanks & Regards,
> > Vinod Kumar
> >
> >
> >
> > --
> > Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html
> >
>