Skip to main content
Solved

Proforma Invoice - filter cost to appear in T&M

  • Jun 28, 2023 1:54 PM UTC
  • 12 replies
  • 265 views
  • Translate All

Forum|alt.badge.img+1

Hi,

There is a way to filter things who appear in T&M Proforma.

If by example we dont want to bill item ABC to the customer (and don’t want to appear on the invoice)?

Could I manage this via Project/Cost budget? Billing rule? Configuration?

Now I delete ABC rows manually.

Thanks

Best answer by iqraharrison

@raphrf are you making sure the non billable transactions do not have the “billable” checkbox checked? that should prevent items from showing up on the list.  

View original

12 replies

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • Jun 28, 2023 1:59 PM UTC

@raphrf What is it you are not wanting to bill?  Are these consistent costs you do not want to bill?

Translate

Forum|alt.badge.img+1
  • Author
  • Captain I
  • Jun 28, 2023 2:01 PM UTC

It’s some InventoryID

Translate

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • Jun 28, 2023 2:31 PM UTC

When entering AP invoice, you can mark line items as non-billable.  On the billing rule you could make a more complicated formula to include and If then statement  IF Inventory Id = x then $0, but that would be all the time.  You can also put the non-billable inventory id’s to a different account group so they will not go through the billing rule.

Translate

Forum|alt.badge.img+1
  • Author
  • Captain I
  • Jun 28, 2023 4:01 PM UTC

Yes I had the same idea to set a selling price(Sales Prices) of 0$ for some Inventory item for this customer, it’s working , but i want to remove the 0$ item at the generation of proforma(and not at the report)

Translate

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • Jun 28, 2023 4:05 PM UTC

@raphrf  Since you are doing T & M Billing, you can uncheck this box

Be careful doing this on a Progress Billing type as it will affect the AIA.

Translate

Forum|alt.badge.img+1
  • Author
  • Captain I
  • Jun 28, 2023 4:18 PM UTC

Hi, I tried to uncheck “Create Lines with Zero Amount and Quantity    “ in billing rule without success. I saw that the Help said two different logic, the first one correspond to my need (or) the second seem to be implemented in the code(and),

My amount is 0$ and appear in proforma

 

Translate

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • Jun 28, 2023 4:50 PM UTC

@raphrf  Do you have quanitity on the transactions? If not, then you will need to enter a case to see why this is not working for you

Translate

Forum|alt.badge.img+1
  • Author
  • Captain I
  • Jun 28, 2023 5:26 PM UTC

Ticket created 

The billing rule
the proforma row at zero amount

 

Translate

iqraharrison
Captain II
Forum|alt.badge.img+9

@raphrf i recently started exploring with rate tables.  i know you can specify projects and inventory IDs which can be set at specific rates (I.E. 0.00) i haven’t tested this out but it could be worth a shot.

 

my other question is, does the inventory ID have a price associated with it?

Translate

Forum|alt.badge.img+1
  • Author
  • Captain I
  • Jul 11, 2023 2:00 PM UTC

@raphrf i recently started exploring with rate tables.  i know you can specify projects and inventory IDs which can be set at specific rates (I.E. 0.00) i haven’t tested this out but it could be worth a shot.

 

my other question is, does the inventory ID have a price associated with it?

Interesting, i never tryed with rates, let me know !

Translate

Heidi Dempsey
Community Manager
Forum|alt.badge.img+3
  • Community Manager
  • Jul 11, 2023 10:06 PM UTC

@raphrf  Since you have billable quantity on the transaction(s) so the line will show up on the Invoice.  

Translate

iqraharrison
Captain II
Forum|alt.badge.img+9
  • Captain II
  • Answer
  • Jul 14, 2023 7:54 PM UTC

@raphrf are you making sure the non billable transactions do not have the “billable” checkbox checked? that should prevent items from showing up on the list.  

Translate