Skip to main content

I'm trying to post multi inv/CN during o ...

Elaine Reilly
I'm trying to post multi inv/CN during one RC, I have rights to apply invoice at RC & allow multiple corr in a closed period is ticked RC> add invoice £40 save and add CN ( £4.05 for o/charge) get this error cannot be submitted when a difference exists
0

Comments

16 comments

Date Votes
  • Elaine Reilly

    Thanks ​Mark for your reply. this makes sense.  I do however have a question regarding the impact on inventory price with this adjustment at receiving.

     

    for example if the original invoice was for 10 bottles of wine at £6.50 ( over charged by 10 per bottle) when the credit note is received, the value of the wine is changed to £6.40 per bottle.  what happens to the inventory price of the item, are they recorded at £6.50, £6.40 ( amended price ) or £6.45 ave price

    0
  • Sophie Waters

    Hi @Elaine Reilly​ ,

     

    It would depend on what settings you have on your portal. I've had a quick look at your portal and it would appear to be set to calculate Average Price.

     

    Best

    Mark

    Fourth​

    0
  • Elaine Reilly

    Thanks for your reply mark, given that we us AVE price. how would this effect the inventory price.  the first receiving would be at £6.50 per bottle then corrected to £6.40 per bottle -  would the inventory price ( ave ) use the £6.50 price or £6.40 price?

     

    ​

    0
  • Elaine Reilly

    Thanks ​Mark for your reply. this makes sense.  I do however have a question regarding the impact on inventory price with this adjustment at receiving.

     

    for example if the original invoice was for 10 bottles of wine at £6.50 ( over charged by 10 per bottle) when the credit note is received, the value of the wine is changed to £6.40 per bottle.  what happens to the inventory price of the item, are they recorded at £6.50, £6.40 ( amended price ) or £6.45 ave price

    0
  • Sophie Waters

    Hi @Elaine Reilly​ ,

     

    It would depend on what settings you have on your portal. I've had a quick look at your portal and it would appear to be set to calculate Average Price.

     

    Best

    Mark

    Fourth​

    0
  • Elaine Reilly

    Thanks for your reply mark, given that we us AVE price. how would this effect the inventory price.  the first receiving would be at £6.50 per bottle then corrected to £6.40 per bottle -  would the inventory price ( ave ) use the £6.50 price or £6.40 price?

     

    ​

    0
  • Sophie Waters

    Hi @Elaine Reilly​ ,

     

    Thank you for raising this.

     

    Your question is a little unclear, but if looks as if the invoice and credit note total doesn't match with the receiving total. 

    When adding the credit note for £4.05 you will need to adjust the receiving by the same amount (either change the qty or price to reflect what the credit note is for).

     

    If this doesn't work for you then please drop us a reply with some screenshots so we can help you review the issue.

     

    Best

    Mark

    Fourth

    0
  • Sophie Waters

    Hi @Elaine Reilly​ ,

     

    Thank you for raising this.

     

    Your question is a little unclear, but if looks as if the invoice and credit note total doesn't match with the receiving total. 

    When adding the credit note for £4.05 you will need to adjust the receiving by the same amount (either change the qty or price to reflect what the credit note is for).

     

    If this doesn't work for you then please drop us a reply with some screenshots so we can help you review the issue.

     

    Best

    Mark

    Fourth

    0
  • Mark Whitmore

    Hi @Elaine Reilly​ ,

     

    It would be the 10 bottles at £6.50 + however many other bottles you have in Inventory at £6.40 divided by the total amount of bottles.

     

    E.G.

     

    10x6.50=65

    50x6.40=320

    65+320=385

    385 divided 60 = £6.41

     

    I hope that helps?

     

    Best

    Mark

    Fourth

    0
  • Mark Whitmore

    Hi @Elaine Reilly​ ,

     

    It would be the 10 bottles at £6.50 + however many other bottles you have in Inventory at £6.40 divided by the total amount of bottles.

     

    E.G.

     

    10x6.50=65

    50x6.40=320

    65+320=385

    385 divided 60 = £6.41

     

    I hope that helps?

     

    Best

    Mark

    Fourth

    0
  • Elaine Reilly

    Hi Mark, this is what I thought.  so if were incorrectly charged and invoiced at the higher price, then corrected the price at receiving to add the credit note, then the inventory price will be overstated​

    0
  • Elaine Reilly

    Hi Mark, this is what I thought.  so if were incorrectly charged and invoiced at the higher price, then corrected the price at receiving to add the credit note, then the inventory price will be overstated​

    0
  • Mark Whitmore

    Hi @Elaine Reilly​ ,

     

    Apologies if I wasn't clear. If you are posting the credit note in the following period then yes the inventory price would be overstated for the previous period.

     

    Best

    Mark

    Fourth

    0
  • Mark Whitmore

    Hi @Elaine Reilly​ ,

     

    Apologies if I wasn't clear. If you are posting the credit note in the following period then yes the inventory price would be overstated for the previous period.

     

    Best

    Mark

    Fourth

    0
  • Elaine Reilly

    ​Hi Mark,  thanks for your reply.  we tested this out and found that if the credit note was added in at the same time as the original invoice. eg received to match invoice £6.50 x 10 ( save and add credit note ) amended price to £6.40 added credit note. The items went into inventory at £6.40 the corrected price.  understand that if the credit note was posted in a different period then the inventory price would be overstated.

     

    Elaine

    0
  • Elaine Reilly

    ​Hi Mark,  thanks for your reply.  we tested this out and found that if the credit note was added in at the same time as the original invoice. eg received to match invoice £6.50 x 10 ( save and add credit note ) amended price to £6.40 added credit note. The items went into inventory at £6.40 the corrected price.  understand that if the credit note was posted in a different period then the inventory price would be overstated.

     

    Elaine

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post