Options

Delete sales invoiced data from database these tables only

ahmedbaahmedba Member Posts: 424
Hi guys IF i want to delete invoiced sales order then if i deleted from back end

i will deleted from these tables as following :

Sales Invoice Header

Sales Invoice Line

Customer Ledger Entry

Detail Customer Ledger Entry

G/l Entry

Are this as following True or False

Thanks

Comments

  • Options
    SavatageSavatage Member Posts: 7,142
    Why do you need to completely erase the existence of an invoice & from the back end?

    Isn't reversing the entry enough, else it looks like illegal activity is taking place.

    Example/ You have an order for $1000.
    Guy gives you $1000 in cash.
    You wipe out any trace of this order & pocket the cash.

    And what do you plan to do with all the inventory postings & value entries?
  • Options
    ahmedbaahmedba Member Posts: 424
    Why i told you I want to delete data from these tables because my case as following :

    http://www.mediafire.com/view/myfiles/#lu9ggaceuejxxp2

    I analysis the proplem i found it come as result to duplicate in Sales invoice No between two databases

    Database A Database B

    JE-PSI-008467 No JE-PSI-008467

    JE-TC-002522 Customer no JE-TC-002552

    When i make transfere data from database B to A it make this conflict so that in

    Sales invoice header

    JE-PSI-008467 JE-TC-002552 this after replaced

    but true must be JE-PSI-008467 JE-TC-002522 because conflict happen because two orderes have same primary key in sales invoice header in No field

    Sales invoice Line

    JE-PSI-008467 JE-TC-002522

    JE-PSI-008467 JE-TC-002552

    How i remove this conflict so that my solution in above is to delete orderes come from Database B

    from database A then modify it in B then import it again

    So that How Can correct the proplem Now.

    thanks
  • Options
    bbrownbbrown Member Posts: 3,268
    So my question would be why are you moving the invoices between databases? If an invoice was posted in Database A, what business does it have in Database B?
    There are no bugs - only undocumented features.
  • Options
    AndwianAndwian Member Posts: 627
    What is the main problem?
    Regards,
    Andwian
  • Options
    ahmedbaahmedba Member Posts: 424
    The main problem is Database B has same sales invoice no in database A
    and after transferred from A to B it become sales invoice no replicate two times
    and in sales invoice header table the record come from database B damage firstly order created because it has same no.
    What i need here to make integration between two branches
    How i solve problem of duplicate Now
  • Options
    bbrownbbrown Member Posts: 3,268
    We understand what you are trying to do. The question is why? What is the business need/justification for this time and effort? Also, since you are havign 2 NAV databases should we assume you have a separate license for each? Or is the second database for reporting only?
    There are no bugs - only undocumented features.
  • Options
    ahmedbaahmedba Member Posts: 424
    Second database for reporting only and First database for transaction
    and two database have developer license
  • Options
    bbrownbbrown Member Posts: 3,268
    ahmedba wrote:
    ...two database have developer license...

    Are you an end-user or a NAV Partner? If you are an end-user, do you just mean your NAV license contains some (or all) of the design granules? What is commonly referred to as "Developer Licenses" are actually NAV Partner license. They should NEVER be installed on a prodcution system.

    If you are only doing reporting, why don't you look to some sort of data warehousing (BI) solution?
    There are no bugs - only undocumented features.
  • Options
    ahmedbaahmedba Member Posts: 424
    Can you told me if delete is only solution which tables i will delete from database
    are this tables only
    Sales Invoice Header

    Sales Invoice Line

    Customer Ledger Entry

    Detail Customer Ledger Entry

    G/l Entry
    Or there are remaining tables
Sign In or Register to comment.