Skip to content

Instantly share code, notes, and snippets.

@radoAngelov
Last active October 26, 2018 13:17
Show Gist options
  • Select an option

  • Save radoAngelov/ead4e3a5a78df08174167c09acc1629e to your computer and use it in GitHub Desktop.

Select an option

Save radoAngelov/ead4e3a5a78df08174167c09acc1629e to your computer and use it in GitHub Desktop.

Case 1: VAT Registered + Manual Line Items + NO Remaining Amount

Generated line items:

[
  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>"superman",
    "quantity"=>1,
    "gross"=>"110.0",
    "net"=>"100.0",
    "vat"=>"10.0",
    "convert_rate"=>"1.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"100.0",
    "auto_generated"=>false,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  },

  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>"batman",
    "quantity"=>1,
    "gross"=>"220.0",
    "net"=>"200.0",
    "vat"=>"20.0",
    "convert_rate"=>"1.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"200.0",
    "auto_generated"=>false,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]

Case 2: VAT Registered + Manual Line Items + Remaining Amount matching Jurisdiction Tax Rate

Generated line items:

[
  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>"superman",
    "quantity"=>1,
    "gross"=>"110.0",
    "net"=>"100.0",
    "vat"=>"10.0",
    "convert_rate"=>"1.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>
     {"list_item"=>
       {"id"=>300,
        "list_name"=>"tax",
        "display_name"=>"GST (10.00%) Goods & Services Tax",
        "value"=>"10.0",
        "remote_id"=>"GST",
        "visible"=>true,
        "created_at"=>"2018-10-26T12:36:28.894+01:00",
        "updated_at"=>"2018-10-26T12:36:28.894+01:00",
        "ref"=>nil,
        "secondary_ref"=>nil,
        "integration_id"=>91}},
    "unit_price"=>"100.0",
    "auto_generated"=>false,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  },

  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"220.0",
    "vat"=>"20.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>
     {"list_item"=>
       {"id"=>300,
        "list_name"=>"tax",
        "display_name"=>"GST (10.00%) Goods & Services Tax",
        "value"=>"10.0",
        "remote_id"=>"GST",
        "visible"=>true,
        "created_at"=>"2018-10-26T12:36:28.894+01:00",
        "updated_at"=>"2018-10-26T12:36:28.894+01:00",
        "ref"=>nil,
        "secondary_ref"=>nil,
        "integration_id"=>91}},
    "unit_price"=>"200.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]

Case 3: VAT Registered + Manual Line Items + Undertaxed

Generated line items:

[
  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>"batman",
    "quantity"=>1,
    "gross"=>"110.0",
    "net"=>"100.0",
    "vat"=>"10.0",
    "convert_rate"=>"1.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"100.0",
    "auto_generated"=>false,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  },
  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"210.0",
    "vat"=>"10.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"200.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]

Case 4: VAT Registered + Manual Line Items + Overtaxed

Generated line items:

[
  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>"superman",
    "quantity"=>1,
    "gross"=>"110.0",
    "net"=>"100.0",
    "vat"=>"10.0",
    "convert_rate"=>"1.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"100.0",
    "auto_generated"=>false,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  },
  {
    "use_tax_rate"=>true,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"230.0",
    "vat"=>"30.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"200.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]

Case 5: VAT Registered + NO Manual Line Items + Remaining Amount matching Jurisdiction Tax Rate

Generated line items:

[
  {
    "use_tax_rate"=>false,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"330.0",
    "vat"=>"30.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"300.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>1448,
        "name"=>"Petty cash",
        "created_at"=>"2018-10-26T12:36:27.085+01:00",
        "updated_at"=>"2018-10-26T12:36:27.085+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1200",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761152",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]

Case 6: VAT Registered + NO Manual Line Items + Undertaxed Adjustment

Generated line items:

[
  {
    "use_tax_rate"=>false,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"100.0",
    "vat"=>"0.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"100.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>17,
        "name"=>"Books",
        "created_at"=>"2018-10-26T12:31:08.767+01:00",
        "updated_at"=>"2018-10-26T12:31:08.767+01:00",
        "category_group_id"=>1,
        "selectable"=>true,
        "code"=>nil,
        "subtype"=>"",
        "remote_id"=>nil,
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  },
  {
    "use_tax_rate"=>false,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"220.0",
    "vat"=>"20.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"200.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>17,
        "name"=>"Books",
        "created_at"=>"2018-10-26T12:31:08.767+01:00",
        "updated_at"=>"2018-10-26T12:31:08.767+01:00",
        "category_group_id"=>1,
        "selectable"=>true,
        "code"=>nil,
        "subtype"=>"",
        "remote_id"=>nil,
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]

Case 7: VAT Registered + NO Manual Line Items + Overtaxed Adjustment

Generated line items:

[
  {
    "use_tax_rate"=>false,
    "use_net"=>false,
    "description"=>".",
    "quantity"=>"1.0",
    "gross"=>"340.0",
    "vat"=>"40.0",
    "tax_rate_user_defined"=>false,
    "tax_rate"=>nil,
    "unit_price"=>"300.0",
    "auto_generated"=>true,
    "category"=>
     {"category"=>
       {"id"=>1447,
        "name"=>"Cheque account",
        "created_at"=>"2018-10-26T12:36:27.075+01:00",
        "updated_at"=>"2018-10-26T12:36:27.075+01:00",
        "category_group_id"=>46,
        "selectable"=>true,
        "code"=>"1-1000",
        "subtype"=>"MYOB Essentials",
        "remote_id"=>"44761151",
        "default_tax"=>nil,
        "tax_id"=>nil}},
    "project"=>nil,
    "project2"=>nil,
    "client"=>nil
  }
]
@radoAngelov
Copy link
Author

Sensitive Inputs

  • Case 3

case 3

  • Case 4

case 4

  • Case 6

case 6

  • Case 7

case 7

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment