POS: error when selling product with stock on hand 0

[Desampa S]

Hi,

I'm having problems when selling a product in the POS application and the stock on hand is zero. I configured the product store in this way:
- One inventory facility = Y
- Is inmmediate fulfilled = Y
- Check inventory = N
- Require inventory = N
- Reserve inventory = Y

When doing a sale in POS screen the error is "Problem with order change: see error logs".
The logs show this error:"Error in simple method [Create an accounting transactions for a sales shipment issuance <D: INVENTORY_ACCOUNT, C: COGS_ACCOUNT> [file:/D:/ofbiz/ofbiz_release10.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]: ; {Could not find enough accounting inventory for product [WG-1111]; remaining quantity: 1>"

If I receive inventory in the facility assigned to the product store adding stock on hand, then I don't have any error.

I want to sell a product without stock and I don't know how to get it.
Am I missing some configuration point?

[Jacques Le Roux]

The basic idea is that should not happens. During a face to face sell you can't seel something you have not in stock.

For instance if you try to sell 2 WG-1111 when you have only 1, a such error will appear I guess

Jacques


From: "Desampa S" <[hidden email]>

> Hi,
>
> I'm having problems when selling a product in the POS application and the
> stock on hand is zero. I configured the product store in this way:
> - One inventory facility = Y
> - Is inmmediate fulfilled = Y
> - Check inventory = N
> - Require inventory = N
> - Reserve inventory = Y
>
> When doing a sale in POS screen the error is "Problem with order change: see
> error logs".
> The logs show this error:"Error in simple method [Create an accounting
> transactions for a sales shipment issuance <D: INVENTORY_ACCOUNT, C:
> COGS_ACCOUNT>
> [file:/D:/ofbiz/ofbiz_release10.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]:
> ; {Could not find enough accounting inventory for product [WG-1111];
> remaining quantity: 1>"
>
> If I receive inventory in the facility assigned to the product store adding
> stock on hand, then I don't have any error.
>
> I want to sell a product without stock and I don't know how to get it.
> Am I missing some configuration point?
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/POS-error-when-selling-product-with-stock-on-hand-0-tp3566130p3566130.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[BJ Freeman]

To take this one step further.
if the customer has it in their hand, you inventory should reflect its
existence.
if your using this as order entry instead then I suggest you use the
order->order entry screen.

=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist

Chat  Y! messenger: bjfr33man


Jacques Le Roux sent the following on 6/1/2011 10:48 AM:

> The basic idea is that should not happens. During a face to face sell
> you can't seel something you have not in stock.
>
> For instance if you try to sell 2 WG-1111 when you have only 1, a such
> error will appear I guess
>
> Jacques
>
>
> From: "Desampa S" <[hidden email]>
>> Hi,
>>
>> I'm having problems when selling a product in the POS application and the
>> stock on hand is zero. I configured the product store in this way:
>> - One inventory facility = Y
>> - Is inmmediate fulfilled = Y
>> - Check inventory = N
>> - Require inventory = N
>> - Reserve inventory = Y
>>
>> When doing a sale in POS screen the error is "Problem with order
>> change: see
>> error logs".
>> The logs show this error:"Error in simple method [Create an accounting
>> transactions for a sales shipment issuance <D: INVENTORY_ACCOUNT, C:
>> COGS_ACCOUNT>
>> [file:/D:/ofbiz/ofbiz_release10.04/applications/accounting/script/org/ofbiz/accounting/ledger/GeneralLedgerServices.xml#createAcctgTransForSalesShipmentIssuance]]:
>>
>> ; {Could not find enough accounting inventory for product [WG-1111];
>> remaining quantity: 1>"
>>
>> If I receive inventory in the facility assigned to the product store
>> adding
>> stock on hand, then I don't have any error.
>>
>> I want to sell a product without stock and I don't know how to get it.
>> Am I missing some configuration point?
>>
>>
>>
>> --
>> View this message in context:
>> http://ofbiz.135035.n4.nabble.com/POS-error-when-selling-product-with-stock-on-hand-0-tp3566130p3566130.html
>>
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>
>

[Desampa S]

I understand your point of view but sometimes we have to sell some items not in stock. For instance:
Example 1 - the product is not in the shop, but I buy it and I'll receive at home directly from the central warehouse
Example 2 - there is an error in the stock quantity but phisically the product is at the shop, and the manager is not today at the shop and nobody can do the stock adjustment until the next day. I must do the sale

I thought that the option Require inventory = N was used for these situations. Other Retail products allow to have negative stock quantity.

[Jacques Le Roux]

Mmm... you are right

Which Release.revision are you using?

I have just tried to buy 10 000 000+ GZ-2644 with OOTB trunk and I have any pb...

Could you try with the OTB Retail Store?

Jacques

From: "Desampa S" <[hidden email]>

>I understand your point of view but sometimes we have to sell some items not
> in stock. For instance:
> Example 1 - the product is not in the shop, but I buy it and I'll receive at
> home directly from the central warehouse
> Example 2 - there is an error in the stock quantity but phisically the
> product is at the shop, and the manager is not today at the shop and nobody
> can do the stock adjustment until the next day. I must do the sale
>
> I thought that the option Require inventory = N was used for these
> situations. Other Retail products allow to have negative stock quantity.
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/POS-error-when-selling-product-with-stock-on-hand-0-tp3566130p3567678.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Desampa S]

We are using release 10.04.
Sorry, what you mean OTB Retail Store?

[Jacques Le Roux]

Please if you use Nabble copy the previous message. Else using an email client we lost some useful information.
BTW Nabble is even suggesting it now

<<You may need to subscribe to this mailing list for your message to be accepted.
 Please respect mailing list etiquette:
  a.. Quote what you reply to and trim it to only the relevant parts. This provides context for those who will read your message by
email.
  b.. Avoid small talk such as "Thank you", "Great"... You can send a private email if you want.>>

I meant OOTB (Out Of The Box), ie using OFBiz as is. I just tried with 10.04 OOTB and it workswell also. Did you attach a website to
the store?

Jacques
PS: sorry I had to send this msg twice, it was refused 1st time, I guess because my C/P from Nabble
Diagnostic-Code: smtp; 552 spam score (5.0) exceeded threshold


From: "Desampa S" <[hidden email]>
> We are using release 10.04.
> Sorry, what you mean OTB Retail Store?
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/POS-error-when-selling-product-with-stock-on-hand-0-tp3566130p3567744.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Desampa S]

Hello Jacques,

everything was aparently right. What I have done is to create a new party as the owner of the facility MyRetailStore. I was using Company as the owner of the facility but this party has LIFO as the COGS method and I couldn't change it to Average Cost. So I created a new party with Average Cost. I defined the necessary accounts in this new party to do a sale and now the problem has disappeared. When I sale a product with stock 0 I can sale it and the stocks gets -1.

Thank you for all your help.