Credit and Rebills in Sales Order

[malaia]

Hello list,

We have a requirement to create a different invoice doc type for rebills (RJ). So I have a invoice version for RJ.

We have 3 type of products (3 GL class) and a SO could have all 3 products. These 3 diff products hit diff. Inv, COGS and Rev account. Now for the credit and rebill situation, inventory is not affected - typically this is some price adjustment, but customer wants a credit for old SO and a clean new invoice.

When we do the credits we want the revenue to hit the original account and when we rebill, we want to hit the same accounts.

The Issue I am having is - I cannot have a inventory interface for the credits and for the rebills, because when we rebill - that item might go on backorder - but the items are actually at customer site.

When I have a non-stock interface (new line types) for the credit and rebill - Since it is non-stock, GL Class comes from line type and all rev. go to one account.

Is bring back the items for credits and taking out of stock for rebills the only option (even though this is just a price adjustment) ????

Any suggestions are appreciated.

Malai Annamalai
D&T San Francisco
OneWorld Xe, Update 6, SP 20

 

[Guest]

You need two types of credit orders, one for product return and one for
price only changes, with different line types.

Try adding a new line type called CD for price only credits. Turn on the
reversal flag, and make the inventory interface equal D. This will validate
the item number, use the item's G/L class, and not affect inventory. (Like
a direct ship line).

Andy Klee
www.JDETips.com

PS. Hi Malai!





Andy Klee
www.JDETips.com

 

[Craig_Potter]

Malia,

Use a line type with "Edit Item Master" checked and the G/L Class should come from the Item.

 

[ame]

My suggestion is to use the D inventory interface on the line type.
(however don't use the D line type... JDE has hardcoded some functionality
into that line type) It will use the G/L class codes from the Items, however
it will not effect quantities. I have used this at numerous customers
without any issues. thanks, Bobby







We have a requirement to create a different invoice doc type for rebills
(RJ). So I have a invoice version for RJ.

We have 3 type of products (3 GL class) and a SO could have all 3 products.
These 3 diff products hit diff. Inv, COGS and Rev account. Now for the
credit and rebill situation, inventory is not affected - typically this is
some price adjustment, but customer wants a credit for old SO and a clean
new invoice.

When we do the credits we want the revenue to hit the original account and
when we rebill, we want to hit the same accounts.

The Issue I am having is - I cannot have a inventory interface for the
credits and for the rebills, because when we rebill - that item might go on
backorder - but the items are actually at customer site.

When I have a non-stock interface (new line types) for the credit and rebill
- Since it is non-stock, GL Class comes from line type and all rev. go to
one account.

Is bring back the items for credits and taking out !

Any suggestions are appreciated.

Malai Annamalai
D&T San Francisco
OneWorld Xe, Update 6, SP 20


_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

 

[malaia]

Thanks Bobby, Craig Potter and Andy. This will work, I have another question.

I have SO/S for original order. C4/ C1 (C1 - D Inventory Interface) for credits and SO/ S1 (S1 - D - Inventory Interface).

I create credit order from history and credit memo. Copy SO/S to create SO/S1 (to have original doc. no. and type in SO/ S1). This all works fine....

When I do the sales update, I see Dr. COGS and A/R and Cr. Inv. and Rev for C4/ C1 and SO/ S1. I was expecting only A/R and Rev for these two doc types.

I tried C1 and S1 with N (non-stock) Inventory interface and Edit non-stock item master - but getting the all 4 entries.

This will definately work, but cost accountants would like to see only 2 entries if possible.

Is there anyother way to accomplish this except changing the processing option in sales update to skip inventory?

Malai Annamalai
D&T San Francisco
OneWorld Xe, Update 6, SP20

 

[ame]

One possibility is to create an inventory clearing account... put your COGS
and inventory pointed both to that account... and then you could summarize
to the G/L.. this would create zero on the G/L...(no effect). Let me
know...thanks, Bobby







I have SO/S for original order. C4/ C1 (C1 - D Inventory Interface) for
credits and SO/ S1 (S1 - D - Inventory Interface).

I create credit order from history and credit memo. Copy SO/S to create
SO/S1 (to have original doc. no. and type in SO/ S1). This all works
fine....

When I do the sales update, I see Dr. COGS and A/R and Cr. Inv. and Rev for
C4/ C1 and SO/ S1. I was expecting only A/R and Rev for these two doc types.

I tried C1 and S1 with N (non-stock) Inventory interface and Edit non-stock
item master - but getting the all 4 entries.

This will definately work, but cost accountants would like to see only 2
entries if possible.

Is there anyother way to accomplish this except changing the processing
option in sales update to skip inventory?


Malai Annamalai
D&T San Francisco
OneWorld Xe, Update 6, SP20


_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail

 

[andyklee]

Malai, by the time you finish this one, you'll be the world's expert in Credits and Rebills! Seriously, you will!
Have you thought about turning off the check availability processing option so that your rebills won't go on back order?

Andy Klee
www.JDEtips.com

 

[malaia]

Andy,

Yes, we thought about turning off availability checking. This will not back order - but will still affect item ledger (@ sales update). Cost accountants do not want this process to affect item ledger.

-Malai
D&T San Francisco
OneWorld Xe, Update 6

 

[vasuvv2300]

bypass updating 4111 in Sales update