You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by ja...@productive1.com on 2018/05/17 19:09:17 UTC

Item For Customer Deposit

I was wondering were can I set up an product that we don't inventory but
I want it to act like a customer deposit.  So when I sell the item it
should reflect as an AR receivable with an offset of a "current
liability"

So here is an example:

Sales Order

Product 124 - Battery  - $5
Product 124C - Core deposit for Product 124 - $2
Sales tax - $.30

When invoiced we would need the Accounting Transaction to be the
following

Credit Sales $5
Credit - Core Deposit $2
Credit Sales Tax Collected $.30
Debit Accounts Receivable $7.30

When the core is returned we would need to create credit memo against
the Core Deposit GL Account

So my question is there an area where we can automatically set and
override the sales account

Thanks,

James

Re: Item For Customer Deposit

Posted by Pierre Smits <pi...@gmail.com>.
Hey James,

I have my doubts about the initial  'not doing inventory' statement in your
posting for the deposit good, as later you state that there is a physical
action to receiving the good when it is returned.

But isn't it so that the 'Product 124' is returned?

So I am going here with the assumption that there is a product in the
catalog called 'Product 124C - Core deposit for Product 124', and that
there is an obligation to have a paper trail for the burden of proof when
crediting for the returned goods.

In order to facility your business process with OFBiz, I suggest to explore
the following:

   1. go to the  'Account' page of the deposit good in the catalog, and
   2. set the appropriate GL account and Account Type for the sale
   3. set the appropriate GL account and Account Type for the return

Aspect #1 will inject the product specific gl account setting in the
invoice details when the sale is materialised into an invoice. The same
applies for credit invoices with aspect #2 on registration of returns.

Next thing to do would set up a promotion for the Product 124, so that when
such a product is ordered the 'Product 124C - Core deposit for Product 124'
will be injected into the order (and will exist in the invoice).

I trust the above helps

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 Thu, May 17, 2018 at 9:09 PM, <ja...@productive1.com> wrote:

> I was wondering were can I set up an product that we don't inventory but
> I want it to act like a customer deposit.  So when I sell the item it
> should reflect as an AR receivable with an offset of a "current
> liability"
>
> So here is an example:
>
> Sales Order
>
> Product 124 - Battery  - $5
> Product 124C - Core deposit for Product 124 - $2
> Sales tax - $.30
>
> When invoiced we would need the Accounting Transaction to be the
> following
>
> Credit Sales $5
> Credit - Core Deposit $2
> Credit Sales Tax Collected $.30
> Debit Accounts Receivable $7.30
>
> When the core is returned we would need to create credit memo against
> the Core Deposit GL Account
>
> So my question is there an area where we can automatically set and
> override the sales account
>
> Thanks,
>
> James
>